Translating OODB Method to RDB Routine

A methodology is introduced for translating from methods in an object-oriented database to routines in a relational database. The approach consists of three steps. The first step is to translate method signature to Persistent Stored Modules signature. The second step is to translate method source language to (function/procedure) routine. The process includes Host Language, OSQL’s Qualification, Query Translation, Update Transaction Translation, and Objects inside Object. The third step is to translate method invocation to routine invocation. According to this approach, object-oriented database methods can be translated to relational database routines that can be executed in the relational database environment assisted by a frame model and case statements listing all possible cases of binding conditions and actions. The significance of the finding is adding an open object-oriented interface on top of relational database system for database interoperability and in the development of an object-relational database management system. 1 I I NTRODUCTI I ON 1.1 Background In the current situation, many companies are using the relational concepts and products for assisting their business decision. Problems in using OODB are in the reliability, performance, cost of migration, and lack of expertise. Therefore, a legacy system installed the object notion is our motivation. Some research papers have introduced some related works regarding the migration from OODB to RDB and vice versa. We all know that the current market has many ORDBMS (Object-Relational Database Management Systems). However, they did not consider migrating object method to its relational counterpart. In this paper, we shall translate from object methods to relational routines. After implementing our methodology in a RDB, users can apply object features in their relational database according to our concepts.